Installing the ADO Client on Windows

The ADO Client installer on Windows requires the Microsoft Windows Installer service. If the ADO Client installer detects that the service is not installed on your machine, or that an older version is installed, a message is displayed. After installing the Microsoft Windows Installer service, you might need to restart your machine. Then you can install the ADO Client.

The ADO Client installer also checks for Microsoft Data Access Components (MDAC). If the installer detects that MDAC 2.7 Service Pack 1 or higher is not installed, an error message is generated.

You must install MDAC. MDAC 2.7 Service Pack 1 is shipped with SequeLink and can be found in the sqlnk60\mdac32 subdirectory on the DataDirect DVD.

To start the ADO Client installer:

If installing from the DataDirect DVD, insert the DVD into the DVD-ROM drive. If you have a local DVD-ROM drive, this typically is drive D. If the DVD-ROM drive is on a network, mount the DVD and create a mapping to the DVD-ROM drive. Then, perform one of the following actions:
If AutoRun for DVDs is enabled and you have a browser, the main installer window displays automatically. Select the product that you want to install; then, follow the instructions to install the product.
If AutoRun for DVDs is not enabled or you do not have a browser, use Windows Explorer to navigate from the root directory of the DVD to the folder for the product that you want to install (\sqlnk60\win\ado). Then, double-click SETUP.EXE.
If installing from files downloaded from the Web, follow the download instructions on the DataDirect Technologies Web site to download the appropriate self-extracting ZIP file. Open the contents of the ZIP file into a directory (for example: C:\temp). Then, navigate to the directory that contains the unzipped files and double-click SETUP.EXE to start the installer.

Installing the ADO Client

Start the SequeLink for ADO installer. When the Welcome window appears, click Next to continue. The License Agreement window appears.
On the License Agreement window, perform one of the following actions:
Accept the agreement by clicking the appropriate option. Then, click Next. The Custom Setup window appears.
Do not accept the agreement by clicking Cancel to exit the installation.
The Custom Setup window allows you choose specific installation options.





Click one or multiple component icons to select the components to install. When you select a component, a description of the component appears in the Feature Description box.
To change the installation directory, click Change. A window appears allowing you to browse and select an installation directory.

When you are satisfied with your settings, click Next.

The Ready to Install the Program window allows you to go back and review your choices before proceeding. If you are ready to install, click Install.
The InstallShield Wizard Completed window appears when the installation has been completed successfully. Click Finish.
For instructions on testing your SequeLink installation, refer to the SequeLink Administrator's Guide.

NOTE: If you want to use the SequeLink Client with Microsoft DTC, you must reboot your machine.

NOTE: If you will be connecting to the SequeLink Server for ODBC Socket with an ADO Client, you must configure the DataSourceProviderTypesFile and DataSourceProviderTypesSection service attributes. Refer to the SequeLink Administrator's Guide.

Silent Installations

When the Microsoft Windows Installer service is installed, the MSIEXEC.EXE file resides in the system directory of your workstation to make silent installations possible for the initial installation of the ADO Client. Silent installations are useful for system administrators who want to create a batch file to execute the initial installation of multiple identical ADO Clients.

To install the ADO Client silently:

Using a command line, change to the directory where the setup.exe file is located. For example, to install from the DVD on a 32-bit machine, change to the sqlnk60\client\win32\ado subdirectory on the DVD. Using a command line, type the following command:

setup /s /v"/qn" 

Then, press ENTER. The installation will proceed, using defaults, without requiring any further interaction. The /s switch specifies a silent installation. Other switches and properties can also be used to customize the installation; see the Microsoft Windows Installer SDK documentation.

NOTE: Users who want to use the SequeLink Client with Microsoft Distributed Transaction Coordinator (MS DTC) must reboot after installation.

To uninstall the ADO Client silently:

Using a command line, change to the directory where the SETUP.EXE file is located. For example, if you installed the ADO Client on a 32-bit machine from the product DVD, change to the sqlnk60\client\win32\ado subdirectory on the DVD. Type the following command:

setup /s /x 

Then, press ENTER. The ADO Client is removed without requiring any further interaction.

Quick Install Images

When the Microsoft Windows Installer service is installed, the MSIEXEC.EXE file resides in the system directory of your workstation to make Quick Install images possible for the initial installation of the ADO Client.

A Quick Install image is a predefined, customized installation image that you can use for the initial installation of the same ADO Client configuration, including data source definitions, on multiple workstations. It helps ensure that all SequeLink Clients in your organization or workgroup are installed and configured in the same way. Minimal user interaction is required to install the Quick Install image.

NOTE: Users who want to use the SequeLink Client with Microsoft Distributed Transaction Coordinator (MS DTC) must reboot after installation.

You can configure a Quick Install image with the following options:

Workstation or Network Installation. If you configure:
A workstation installation, the ADO Client must be installed on each workstation.
A network installation, the ADO Client is installed at a network location and each workstation can share this network version. Before the network version can be used, the Quick Install Image must be run on each workstation.
Installation Directory. On a workstation installation, you can specify the directory where the ADO Client will be installed.
Default Data Sources. Your Quick Install image can create a set of default data sources. First, you must create a data source file (.OSF) using the SequeLink Data Source SyncTool Administrator. For more information about exporting data source definitions to data source files, refer to the SequeLink Administrator's Guide.

NOTE: Quick Install images only support data source files that specify import in Merge or Overwrite mode.

Creating a Quick Install Image

Using a command line, change to the directory where the setup.exe file is located. For example, to install from the DVD on a 32-bit machine, change to the sqlnk60\client\win32\ado subdirectory on the DVD.
Using a command line, type the following command:

setup /a

Then, press ENTER.

The Welcome window appears. Click Next to continue.
The next window prompts you to choose a Network or a Workstation Quick Install image.

Select the type of Quick Install image to create:

For a Network Quick Install image, select the Create a Network Quick Install image option and click Next. Skip to Step 6.
For a Workstation Quick Install image, select the Create a Workstation Quick Install image option and click Next. Continue with Step 5.
If you are creating a Workstation Quick Install image, the Destination Folder window allows you to specify a folder on the workstation where the ADO Client will be installed. The default destination folder is C:\Program Files\DataDirect\slado60.

When you are satisfied with your settings, click Next.

Click Change to choose another folder. When you are satisfied with your choice, click Next to continue. Continue with the next step.

The Custom Setup window allows you choose specific installation options. Click one or multiple component icons to select the components to install. When you select a component, a description of the component appears in the Feature Description box. To install a component, click the drop-down arrow in the icon and select This feature, and all subfeatures, will be installed on your local hard drive. The red X disappears from the icon.





The Create Default Data Sources window allows you to choose whether to create default data sources.
If you click No, skip to Step 9.
If you click Yes, go to Step 8.
If you choose to create default data sources, the OSF File Location window is displayed. Click Browse to specify the path to the appropriate data source file. Then, click Next.

NOTE: Quick Install images only support data source files that specify import in Merge or Overwrite mode.

In the Network Location window, type the directory where the Quick Install image will be saved in the Network location field, or click Change to navigate to a directory. When you are satisfied with your choice, click Install.
The InstallShield Wizard Completed window appears when the installation has been completed successfully. Click Finish.

Running a Quick Install Image

To run a Quick Install image, the Microsoft Windows Installer must be available on each workstation. The image can also be installed silently. See "Silent Installations" for more information about silent installations.

To perform a Quick Install:

Use one of the following methods to run the Quick Install image from your workstation:
Use Windows Explorer to navigate to the network directory containing the Quick Install image. Double-click DataDirect SequeLink 6.0 Client for ADO.msi.
Verify that the Windows installer MSIEXEC.EXE file is on your path and, using a command line, type the following command:

msiexec /i "network_location\DataDirect SequeLink 6.0 Client for ADO.msi"

where network_location is the location of the Quick Install Image file; then, press ENTER.

The Welcome window appears. Click Next to continue.
The Ready to Install the Program window appears. If you are ready to install, click Install.
The InstallShield Wizard Completed window appears when the installation has been completed successfully. Click Finish.
For instructions on testing your SequeLink installation, refer to the SequeLink Administrator's Guide.

Completing the ODBC Socket and JDBC Socket Installation for the ADO Client

NOTE: This procedure applies to both SequeLink Server for JDBC Socket and SequeLink Server for ODBC Socket.

From the SequeLink Manager Snap-in, select SequeLink 6.0 Manager. For detailed instructions on starting the MMC and working with the SequeLink Manager Snap-in, refer to the SequeLink Administrator's Guide.
Select the SequeLink Agent.
Select SequeLink Services.
Select SLSocket60.
Select Configuration.
Select Data Source Settings.
Select Default.
Select Advanced. The service attributes are displayed.





Right-click the DataSourceProviderTypesFile service attribute, and select Properties. The Properties window appears.
In the Value field, type \installdir\bin\swsoc.ini, where installdir is the SequeLink installation directory.
Click OK. The attribute is changed.
Right-click the DataSourceProviderTypesSection service attribute, and select Properties. The Properties window appears.
In the Value field, type the name of the section of the ProviderTypes file that will contain the data type information for the provider. For example, if you are connecting to an Oracle database, you might type Oracle in this field.
Click OK. The attribute is changed.
Save the configuration.
Open the swsoc.ini file and check the data type mappings between the ADO data types and the data types used by the backend ODBC driver.

NOTE: If the data type mappings for the backend ODBC driver are not in the swsoc.ini file, you must add them manually.

Modify the file as needed, then save the swsoc.ini file.